<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<%@ include file="IsProff.jsp"%>
<%@ include file="..\master\head.jsp"%>
</head>
<body>

<div id="container">
<div id="wrapper">
<div id="sidebar">
<div id="sb_top"><%@ include file="..\master\sbTop.jsp"%>
</div>

<div class="sb_content"><!--##########--> <!-- Start Menu --> <%@ include
	file="..\master\Profmenu.jsp"%> <!-- Profile -->
<%@ include file="..\master\profile.jsp"%> <!-- links -->
<%@ include file="..\master\links.jsp"%>
<div class="copyright"><%@ include file="..\master\copyright.jsp"%>
</div>
</div>
<!-- /sb_content --></div>
<!-- /sidebar --> <!-- Top -->
<div id="header"><%@ include file="..\master\header.jsp"%>
</div>


<!-- Start main content -->
<div id="content">
<div id="intro">
<div class="intro_t">
<h1><span>..</span>Welcome to<span>..</span></h1>
<h2>student project management system</h2>

</div>
</div>
<!-- /intro -->

<h1>View All Withdrawn Projects</h1>
<%@ page import="java.sql.*"%> <%
 	String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
 	try
 	{
 		Class.forName(driver);

 		Connection connection = DriverManager.getConnection(
 				"jdbc:odbc:SPMS", "", "");

 		Statement statement = connection.createStatement();

 		String query = "select Project.ID,Title,Descr,FirstName,LastName from Project,Professor where Validated = 2 and Professor.Id = ProfessorId"
 				+ (session.getAttribute("comm") == "com" ? ""
 						: " and ProfessorId = "
 								+ session.getAttribute("ProfID"));
 		// Execute query and save results.
 		ResultSet res = statement.executeQuery(query);
 %>
<form action="../DB/deleteProject.jsp" method="post">
<table align="center">
	<tr>
		<td></td>
	</tr>
	<tr>

		<th>Title</th>
		<th>
		<th>Description</th>
		<th>
		<th>Professor</th>
	</tr>
	<%
		String projId;
			while (res.next())
			{
				projId = res.getString(1);
				out.print("<tr><td><a href='showProject.jsp?projId="
						+ projId + "' >" + res.getString(2)
						+ "</a><td><td>" + res.getString(3) + "</td>");
				out.println("<td><td>" + res.getString(4) + " "
						+ res.getString(5) + "</td></tr>");
			}
	%>

</table>
</form>
<%
	} catch (ClassNotFoundException cnfe)
	{
		out.println("No such class: " + driver);
	} catch (SQLException se)
	{
		out.println("SQLException: " + se);
	}
%>
</div>
<!-- /content --></div>
<!-- /wrapper -->
<div class="clear">&nbsp;</div>
<!-- Important! Fix the problem of height in Firefox --></div>
<!-- /Container -->


</body>
</html>
